約 4,436,729 件
https://w.atwiki.jp/vocaloidenglishlyric/pages/415.html
【Tags Miku Powapowa-P S tS】 Original Music title ストロボライト English music title Strobe Light / Strobo Light Romaji music title Sutorobo Raito Music Lyrics written, Voice edition by ぽわぽわP(Powapowa-P) Music arranged by ぽわぽわP(Powapowa-P) Singer(s) 初音ミク (Hatsune Miku) Click here for the original Japanese Lyrics English Lyrics (translated by ikuy398): Don t you notice me yet? I m starting to walk in ways I believe in. There you go. Right. I knew it. I m the same as ever Maybe I ll try to start walking? In that distant time I m looking for meaning in life The sound s bounding rhythmically If we could put into words every second someone lives on We feel ourselves live on like scattering words about If we could put into words every second someone lives on We feel ourselves live on like scattering words about Here. "Now, what you were seeing is your own self facing yourself on that day Here, again." Sort of. So much happened, but I kept on living I ll go again being still myself on that day I m looking for meaning in life ...I walk because I was born If we could put into words every second someone lives on We feel ourselves live on like scattering words about If we could put into words every second someone lives on We feel ourselves live on like scattering words about Here. If I can put into words every second I ve lived I should be able to start walking again. ...Like you did one day Romaji lyrics (transliterated by haru47): mada kizukanai no kana? boku wa boku rashiku arukidashite iru no sa. hora, mata. sou da. wakatte ita no sa. boku wa konomama sa. aruki dashite miyou kana? tooi ano toki. boku wa ikiru imi wo sagasu . rizumikaruni oto ga hanerunda. dareka ga ikiteru ichibyou-zutsu kotoba ni dekita nar aba bokura wa ikiteku ki ga suru no sa kotoba wo baramaku you ni dareka ga ikiteru ichibyou-zutsu kotoba ni dekita nara ba bokura wa ikiteku ki ga suru no sa kotoba wo baramaku you ni hora. "ima kimi ga miteta no wa ano hi no jibun to mukiau kimi jishin sa. hora, mata." ...maana. nanda kanda de sa, boku wa ikite ita ano hi to kawaranu mama mata. yukunda. boku wa ikiru imi wo sagasu ...umareta kara boku wa arukunda. dareka ga ikiteru ichibyou-zutsu kotoba ni dekita naraba bokura wa ikiteku ki ga suru no sa kotoba wo baramaku you ni dareka ga ikiteru ichibyou-zutsu kotoba ni dekita naraba bokura wa ikiteku ki ga suru no sa kotoba wo baramaku you ni hora. boku ga ikitekita ichibyou-zutsu kotoba ni dekiru no nara boku wa mata arukidaseru hazu da. ...itsuka no kimi no you ni. [Powapowa-P, PowapowaP]
https://w.atwiki.jp/vocaloidenglishlyric/pages/631.html
【Tags Akuno-P Len Rin tB tD S】 Original Music title 砂漠のBLUEBIRD English music title Desert Blue Bird / Blue Bird of Desert Romaji music title Sabaku no BLUEBIRD Music Lyrics written, Voice edited by mothy \ 悪ノP(Akuno-P) Music arranged by mothy \ 悪ノP(Akuno-P) Main Singer(s) 鏡音レン (Kagamine Len), chorus by 鏡音リン (Rin Kagamine) Click here for the original Japanese Lyrics English Lyrics (translated by animeyay): In a world buried in the sands, we are searching for the blue bird. No matter how difficult, as long as I'm with you, surely we will overcome any trouble we face. In this world with its civilization destroyed, a granny appeared before my little sister and me, imploring us to seek out the blue bird in order to save this world. It's supposedly a desert blue bird. Suddenly we had been entrusted with the fate of the entire world. Having loaded our car full with hope and faith, we began our journey. The blue bird is a legend, a miracle said to grant all and every wish. After a long journey, we finally discovered the blue bird's whereabouts. With the huge building crumbling onto them, the people were all too scared to set their feet into it. As I was still hesitating about whether to enter, you swiftly ran into it for my sake. Oh sister, you used to always tremble in fear behind me no matter what was happening. But now, with courage gathered in your heart, you are about to enter that building. In a world buried in the sands, you have sought out the blue bird. In my arms, with your eyes shut, you will never wake up again. In this facility plagued with radioactive contamination, what I had lost was way too precious to me, so there I made my wish to the blue bird. As you slowly opened your eyes again, the blue bird disappeared into somewhere else. Ahead of what we had journeyed through, was the boundary line of the world. There, was an ocean, blue and vast... Everything will actually start from here, as we must rebuild this world with our own hands. No matter how difficult, as long as I'm with you, surely we will overcome any trouble we face. Desert Blue Bird, it is a miracle. Romaji lyrics (transliterated by animeyay): Suna no naka umoreta sekai bokura wa sagashite iru n da aoi tori tsurakute mo kimi to issho nara kitto norikoerareru Bunmei no horonda kono sekai bokura kyoudai no mae ni arawareta rouba no tanomi goto sekai o sukuu tame no aoi tori mitsukedashite hoshii Sore wa sabaku no blue bird totsuzen yudanerareta sekai no yukusue kuruma ni kibou o tsumekonde bokutachi no tabi ga hajimatta Aoi tori sore wa densetsu arayuru negai o kanaete kureru kiseki nagai tabi bokura wa mitsuketa aoi tori no ibasho Kuzurekaketa kyodai na tatemono kesshite fumiirete wa ikenai to osorete iru hitobito chucho suru boku no tame ni kimi wa hitori de kakedashita Nanika okireba itsumo boku no senaka de furuete ita kowagari na imouto kokoro ni yuuki o tsumekonde kimi wa tatemono ni haitte'ku Suna no naka umoreta sekai kimi wa mitsukedashita n da aoi tori ude no naka me o tojite iru kimi mou mezame suru koto wa nai Kaku de osen sarete ita shisetsu ushinatta mono wa amari ni mo ookii boku wa aoi tori ni negatta Kimi wa futatabi me o samasu aoi tori wa dokoka e kiesatta Kimi to boku aruita sono saki tadoritsuita sekai no hate soko ni wa aokute hiroi umi ga atta Subete wa kore kara hajimaru n da jibuntachi no te de sekai o tsukurinaosu n da tsurakute mo kimi to issho nara kitto norikoerareru Desert Blue Bird sore wa kiseki [mothy, Akuno-P, AkunoP]
https://w.atwiki.jp/vocaloidenglishlyric/pages/761.html
【Tags Hobonichi-P Miku VY1 tI K】 Original Music title 恋なんか知らない [恋愛感染症#1] English music title I Have No Idea What Love Is [Infection Disease#1] Romaji music title Koi nanka Shira nai [Renai Kansenshou#1] Music Lyrics written, Voice edition by anemomania / ほぼ日P (Hobonichi-P) Music arranged by anemomania / ほぼ日P (Hobonichi-P) Singer(s) 初音ミク (Hatsune Miku), Chorus by VY1 MIZKI Click here for the original Japanese Lyrics English Lyrics (translated by motokokusanagi2009): In this loveless world What should we expect? Not knowing how exciting love is Who are we supposed to be meant to meet? I know even what "Love" is It was written in the textbook I recall it is an infection That was eradicated about 50 years ago That virus resulted in Leading people to many symptoms; Heartbeats, dizziness and chest pain I know even what "Love" is I found it in the library It was such a sad story in an old novel People in old times are vulnerable to the infection They blindly fell for love and lost themselves But why in the world Did they repeat the same thing over and over? All they did was crying, laughing And hurting each other In this loveless world What should we expect? Not knowing how exciting love is Who are we supposed to be meant to meet? I know even what "Love" is In her room "Don't tell about this to grandpa, OK?" My grandma told me about it Sometimes filling her eyes with tears Or making her cheeks blush She recalled the old "Love" As if she were dreaming Unfortunately how she felt isn't understandable At all for us How heart ache and affection work is What we know as a knowledge We take it for granted That we could get away from love is fortunate But I doubt if we're really happy Being able to free from love pains I have no idea what "Love" is It existed a long time ago In the time I wasn't even born Love was such a wonderful sickness Romaji lyrics (transliterated by motokokusanagi2009): ren'ai o ushinatta kono sekai de watashi tachi wa nani o sagasu no darō ka koi suru tokimeki o shira nai mama watashi tachi wa dare to deau no darō ka "koi" kurai shitteru yo kyōkasho ni notteta tashika gojū nen hodo mae ni konzetsu sareta kansen shō uirusu ga motarashita moro moro no shōjō dōki memai kōchō soshite mune no itami "koi" kurai shitteru yo toshokan de mitsuketa ōmukashi no shōsetsu no kanashī monogatari mukashi no hito tachi wa kansen ni yowaku te yatara to koi ni ochi tari sōzō ga tsuka nai demo ano hito tachi wa nande onaji koto o kuri kaeru noka nai tari warattari itsumo kizu tsuke au dake nanoni ren'ai o ushinatta kono sekai de watashi tachi wa nani o sagasu no darō ka koi suru tokimeki o shira nai mama watashi tachi wa dare to deau no darō ka "koi" kurai shitteru yo obā chan no oheya de ojī chan niwa naisho datte hanashi te kureta koto ga aru yo tokidoki namida gun dari kao akarame nagara furui "koi" o omoi dashi teta yume o miteru yōni demo obā chan no kanjō wa watashi tachi niwa wakara nai setsunasa mo itoshisa mo chishiki dewa rikai dekiru noni ren'ai o manugareta watashi tachi wa atarimae no koto to omotte iru kedo koi suru kurushimi kara jiyū ni nari shiawase ni nareta to ieru no darō ka "koi" nanka shira nai yo sore wa tōi mukashi watashi ga umarete inai koro atta suteki na yamai [anemomania, Hobonichi-P, HobonichiP]
https://w.atwiki.jp/banzai_guardian/pages/22.html
Member Lists メンバーリストはこちらを御覧ください。 -- メンバーリスト -- 下記リストは、過去の記事をあくまで履歴として残してあります。 2010年4月22日 現在の、Banzai Guardianのギルド所属者リストです。 同時に複数キャラをプレイされている方は、Altキャラクターもリスト内に入っています。 ★=メインキャラクター番号 NAME CLASS TANK DPS HEAL PROFESSION 備考 01 Keinsky(GM) ★ Paladin ○ ○ Mining / Blacksmith Keindulf Mage ○ Alchemy / Herbalism Keinstar Druid ○ Skinning / Leatherworking Keindude Shaman ○ ○ Mining / Jewelcrafting Bitpanther Paladin ○ ○ Tailoring / Enchanting Gontan Priest ○ Herbalism / Inscription 02 WolfTrance ★ Druid ○ ○ Mining / Engineering Wolfwitch Mage ○ Enchanting / Jewelcrafting WolfLady Warlock ○ Herbalism / Alchemy 休止 WolfGuy Warrior ○ Mining / Blacksmith 休止 03 Celeth ★ Priest ○ ○ Mining / Jewelcrafting Celexe Warlock ○ Tailoring / Skinning Celett Priest ○ Tailoring / Herbalism Celein Paladin ○ Mining / Blacksmith Celeor Warrior ○ Mining / Blacksmith 04 Pikappa ★ Hunter ○ Alchemy / Herbalism Suica Hunter ○ Skinning / Letherworking Kapparoll Paladin ○ Mining / Blacksmith Rollpan Paladin ○ Enchanting / Jewelcrafting Pitappa Rogue ○ Skinning / Mining 05 Kurokky ★ Hunter ○ Letherworking / Skinning Kuroe Priest ○ Enchanting / Tailoring Kurozu Warrior ○ Mining / Blacksmith 06 Ayuna ★ Warlock ○ Herbalism / Tailoring Usaginuko Death Knight ○ ○ Enchanting / Blacksmith Usagineko Hunter ○ Skinning / Leatherworking Usacat Druid ○ ○ Herbalism / Inscription Rabbicat Priest ○ ○ Herbalism / Alchemy Kotone Paladin ○ ○ Mining / Blacksmith 07 Saaria ★ Shaman ○ Skinning / Leatherworking 08 Nekoris ★ Druid ○ Jewelcrafting / Mining Nekomint Warrior ○ ○ Herbalism / Alchemy Nekotto Shaman ○ Alchemy / Herbalism Pufy Mage ○ Enchanting / Tailoring 09 Jijihippow ★ Hunter ○ Mining / Engineering Hippow Warrior ○ ○ Alchemy / Herbalism Mamahippow Warlock ○ Tailoring / Enchanting 10 Dacci ★ Rogue ○ Alchemy / Herbalism 復活 Datched Shaman ○ ○ Alchemy / Herbalism 復活 11 Tiltowait ★ Paladin ○ Mining / Blacksmith Meteorstrike Shaman ○ ○ Alchemy / Herbalism Moccos Mage ○ 12 Ggrant ★ Rogue ○ Skinning / Leatherworking Danch Druid ○ ○ Skinning / Herbalism 13 Aconitum ★ Death Knight ○ Inscription / Herbalism Yukine Priest ○ ○ Tailoring / Enchanting Frederica Mage ○ Alchemy / Herbalism 14 Kokesix ★ Mage ○ Alchemy / Herbalism 15 Shermie ★ Warlock ○ Alchemy / Herbalism 16 Havocwreaker ★ Death Knight ○ ○ Enchanting / Mining Xaero Hunter ○ Jewelcrafting / Mining 17 Amberlight ★ Rogue ○ Engineering / Mining Silvergrove Druid ○ ○ Enchanting / Inscription 18 Marinaxx ★ Mage ○ Alchemy / Herbalism 19 Piper ★ Shaman ○ ○ Engineering / Mining 20 Fliptop ★ Paladin ○ ○ Enchanting / Inscription 21 Tokinoe ★ Death Knight ○ Jewelcrafting / Mining Gontaro Paladin ○ Blacksmith / Herbalism Lisakura Shaman ○ Alchemy / Enchanting 22 Gigagora ★ Paladin ○ ○ Blacksmith / Mining 23 Tredas ★ Druid ○ Leatherworking / Skinning 注:順不同。w休部中・・・ 番号 NAME CLASS TANK DPS HEAL PROFESSION 備考 01 Jelly ★ Warlock ○ Enchanting / Tailoring 02 Irisia ★ Hunter ○ Mining / Engineering Shamisen Shaman ○ Mining / Skinning 03 Alsipsclar★ Rogue ○ Mining / Herbalism 04 Curryudon★ Warrior ○ Mining / Blacksmith お世話になった方々 番号 NAME CLASS TANK DPS HEAL PROFESSION 備考 01 Datchy Warrior ○ Enchanting / Herbalism 02 Rastel ★ Warlock ○ Blacksmith / Engineering 03 Amakura ★ Warrior ○ ○ Jewelcrafting / Enchanting 04 Chaosmender ★ Priest ○ Jewelcrafting / Mining ※復活をお待ちしてます!
https://w.atwiki.jp/konkensyu/pages/13.html
Option Explicit Sub 数値代入(カテゴリ As Variant, フラグ As Variant, 範囲 As Variant, 対象列 As Integer) Dim i As Integer, j As Integer, k As Integer, sRange As Range, sName As String 該当月に関数代入(PJPLをSUMIFする) Workbooks(カテゴリ).Activate If フラグ = 1 Then j = 7 Else j = 3 End If 「○」から「●」までのシートで関数代入~値化~合計関数戻し For i = j To Worksheets.Count - 1 Worksheets(i).Activate With Worksheets(i) ※$ZZ$8は十分値により修正の可能性有 .Cells(4, 対象列).Formula = "=SUMIF(" 範囲 "!$C$6 $ZZ$6,$B$2," 範囲 "!$C8 $ZZ8)" .Cells(4, 対象列).Copy .Range(Cells(4, 対象列), Cells(108, 対象列)).PasteSpecial Paste =xlFormulas .Range(Cells(4, 対象列), Cells(108, 対象列)).Copy .Range(Cells(4, 対象列), Cells(108, 対象列)).PasteSpecial Paste =xlValues End With For k = 1 To 105 Select Case k Case 12, 16, 29, 49, 53, 54, 55, 62, 67, 80, 81, 86, 89, 92, 93, 96, 100, 101, 105 Cells(k + 3, 対象列).Select Selection.FillRight End Select Next カーソルをA1セルに移動 Range("A1").Select Next Worksheets.Add(Before =Worksheets(1)).Name = "temp" For i = j + 1 To Worksheets.Count - 1 Cells(i, 1) = Worksheets(i).Name Next Set sRange = Cells(j + 1, 1).CurrentRegion With ActiveSheet.Sort .SortFields.Clear .SortFields.Add Key =Cells(j + 1, 1), SortOn =xlSortOnValues, Order =xlAscending .SetRange sRange .Apply End With For i = 1 To sRange.Rows.Count sName = Worksheets("temp").Cells(i + j, 1) Worksheets(sName).Move after =Worksheets(i + j - 1) Next Application.DisplayAlerts = False Worksheets("temp").Delete Application.DisplayAlerts = True End Sub Sub グループ判定(GP As String, FILE As String, AM1部 As String, AM2部 As String, MM室 As String, IMS合計 As String) If GP = "アカウントマネジメント1部" Then FILE = AM1部 ElseIf GP = "アカウントマネジメント2部" Then FLE = AM2部 ElseIf GP = "メディアマーケティング室" Then FILE = MM室 Else FILE = IMS合計 End If End Sub Sub BtoB_PJPL作成マクロ() エラーの際は「エラー処理」へ On Error GoTo エラー処理 変数定義 Dim SHEET_元帳 As Variant, SHEET_ピボット As Variant, SHEET_PJ列別PL As Variant Dim SHEET_存在判定 As Variant, SHEET_追記用PL As Variant, SHEET_ST管理表 As Variant Dim FILE_AM1部 As Variant, FILE_AM2部 As Variant, FILE_MM室 As Variant, FILE_IMS合計 As Variant, FILE_MACRO As Variant Dim ARRAY_追記ラベル As Variant Dim RANGE_ピボット As Variant, RANGE_ST管理表 As Variant, PATH_PJ列別PL_外部用 As Variant, PATH_データ格納 As Variant Dim COUNT_PJ As Variant, COUNT_行 As Variant, COLUMN_ST管理表 As Variant Dim COUNT_NEWPJ As Variant, SHEET_NEWPJPL As Variant, START_NEWPJ As Variant, END_NEWPJ As Variant Dim i As Variant, j As Variant, COLUMN_MONTH As Integer Dim xPCach As PivotCache, xPTbl As PivotTable Dim BEFORE_GP As String, AFTER_GP As String, JUDGE_GP As String Dim BEFORE_FILE As String, AFTER_FILE As String, FILE As String 名称代入 SHEET_元帳 = "元帳" SHEET_ピボット = "ピボットテーブル" SHEET_PJ列別PL = "PJPL" SHEET_存在判定 = "存在シート判定" SHEET_追記用PL = "追記用PL" SHEET_ST管理表 = Worksheets(Worksheets.Count).Name FILE_AM1部 = "アカウントマネジメント1部.xlsx" FILE_AM2部 = "アカウントマネジメント2部.xlsx" FILE_MM室 = "メディアマーケティング室.xlsx" FILE_IMS合計 = "IMS事業部(BtoB)合計.xlsx" FILE_MACRO = ActiveWorkbook.Name ARRAY_追記ラベル = Array("事業部コード", "事業部", "部室コード", "部室名", "グループコード", "グループ名") PATH_データ格納 = ActiveWorkbook.Path PATH_PJ列別PL_外部用 = "[" FILE_MACRO "]" SHEET_PJ列別PL 変数の値代入 COUNT_行 = Worksheets(SHEET_元帳).Range("A1").End(xlDown).Row ※$AG$2000は十分値により修正の可能性有 RANGE_ST管理表 = " " SHEET_ST管理表 " !$A$12 $AG$2000" COLUMN_MONTH = Range("L3").Value COLUMN_ST管理表 = Range("I4").Value 各種ファイルオープン(AM1・AM2・MM・合計)⇒マクロシートに戻す Workbooks.Open PATH_データ格納 "\" FILE_AM1部 Workbooks.Open PATH_データ格納 "\" FILE_AM2部 Workbooks.Open PATH_データ格納 "\" FILE_MM室 Workbooks.Open PATH_データ格納 "\" FILE_IMS合計 Workbooks(FILE_MACRO).Activate //--元帳操作 With Worksheets(SHEET_元帳) .Activate .Range("Q1").Value = ARRAY_追記ラベル(0) .Range("R1").Value = ARRAY_追記ラベル(1) .Range("S1").Value = ARRAY_追記ラベル(2) .Range("T1").Value = ARRAY_追記ラベル(3) .Range("U1").Value = ARRAY_追記ラベル(4) .Range("V1").Value = ARRAY_追記ラベル(5) .Range("Q2").Formula = "=VLOOKUP($K2," RANGE_ST管理表 "," COLUMN_ST管理表 "-5,0)" .Range("R2").Formula = "=VLOOKUP($K2," RANGE_ST管理表 "," COLUMN_ST管理表 "-4,0)" .Range("S2").Formula = "=VLOOKUP($K2," RANGE_ST管理表 "," COLUMN_ST管理表 "-3,0)" .Range("T2").Formula = "=VLOOKUP($K2," RANGE_ST管理表 "," COLUMN_ST管理表 "-2,0)" .Range("U2").Formula = "=VLOOKUP($K2," RANGE_ST管理表 "," COLUMN_ST管理表 "-1,0)" .Range("V2").Formula = "=VLOOKUP($K2," RANGE_ST管理表 "," COLUMN_ST管理表 ",0)" .Range("Q2 V2").Copy .Paste Range(.Range("Q2"), .Cells(COUNT_行, 17)) End With Set RANGE_ピボット = Worksheets(SHEET_元帳).Range("A1", Cells(COUNT_行, "V")) 範囲設定 Worksheets.Add Before =Worksheets(SHEET_元帳) ActiveSheet.Name = SHEET_ピボット //--ピボットテーブル作成 ①ピボットキャッシュ作成 Set xPCach = ActiveWorkbook.PivotCaches.Create _ (SourceType =xlDatabase, SourceData =RANGE_ピボット) ②ピボットキャッシュを元にピボットテーブルを作成 Set xPTbl = xPCach.CreatePivotTable _ (TableDestination =Range("A3"), TableName ="Pivot1") ③ピボットテーブルの行・列・値などにフィールドを配置 With ActiveSheet.PivotTables("Pivot1") 行フィールド設定 .AddFields RowFields =Array("PL番号", "PL科目") 列フィールド設定 With .PivotFields("プロジェクトコード") .Orientation = xlColumnField .Position = 1 End With With .PivotFields("プロジェクト名称") .Orientation = xlColumnField .Position = 2 End With データフィールド設定 With .PivotFields("金額") .Orientation = xlDataField .Function = xlSum .NumberFormat = "#,##0_ " End With 集計行非表示 .PivotFields("PL番号").Subtotals(1) = False .PivotFields("プロジェクトコード").Subtotals(1) = False .InGridDropZones = True .RowAxisLayout xlTabularRow End With ActiveSheet.Range("C6").Select ActiveWindow.FreezePanes = True //--PJPLシート追加~PJコードペースト Worksheets.Add Before =Worksheets(SHEET_ピボット) ActiveSheet.Name = SHEET_PJ列別PL Worksheets(1).Activate ActiveSheet.Range("B8", "D117").Copy ActiveSheet.Paste Worksheets(SHEET_PJ列別PL).Range("A3") Worksheets(SHEET_PJ列別PL).Range("A B").Columns.AutoFit With Worksheets(SHEET_ピボット) .Activate COUNT_PJ = .Range("A5").End(xlToRight).Column .Range("C4", Cells(5, COUNT_PJ)).Copy .Paste Worksheets(SHEET_PJ列別PL).Range("C6") .Range("C8").Select Worksheets(SHEET_ピボット).Activate COUNT_PJ = ActiveSheet.Range("A5").End(xlToRight).Column ActiveSheet.Range("C4", Cells(5, COUNT_PJ)).Copy ActiveSheet.Paste Worksheets(SHEET_PJ列別PL).Range("C6") End With ActiveWindow.FreezePanes = True ActiveWindow.Zoom = 85 //--関数代入~PJPL全体の完成(関数のまま)※Case文使う方がわかりやすい With Worksheets(SHEET_PJ列別PL) ※$ZZ$50は十分値により修正の可能性有 .Activate .Range("C8").Formula = "=IF(ISERROR(MATCH($A8,ピボットテーブル!$A$6 $A$100,0)),0,INDEX(ピボットテーブル!$C$6 $ZZ$100,MATCH($A8,ピボットテーブル!$A$6 $A$100,0),MATCH(C$6,ピボットテーブル!$C$4 $ZZ$4,0)))" .Range("C8").Copy For i = 1 To 105 Select Case i Case 12, 16, 29, 49, 53, 54, 55, 62, 67, 80, 81, 86, 89, 92, 93, 96, 100, 101, 105 Case Else .Paste Cells(i + 7, "C") End Select Next .Range("C8", "C112").Copy .Paste Range(.Range("C8"), .Cells(112, COUNT_PJ)) End With //--存在シート判定 ※6月作成後、起点セル変更H3⇒I3 2011/7/14 Worksheets(SHEET_ピボット).Activate COUNT_PJ = ActiveSheet.Range("A5").End(xlToRight).Column ActiveSheet.Range("C4", Cells(5, COUNT_PJ)).Copy With Worksheets(SHEET_存在判定) .Activate .Range("I3").PasteSpecial Paste =xlValues, Transpose =True COUNT_PJ = .Range("I3").End(xlDown).Row START_NEWPJ = .Range("B3").End(xlDown).Row + 1 END_NEWPJ = START_NEWPJ ※$B$1000は十分値により修正の可能性有 .Range("K3").Formula = "=IF(ISERROR(VLOOKUP($I3,$B$3 $B$1000,1,0)),""NG"",""OK"")" .Range("K3").Copy .Paste Range(.Range("K3"), .Cells(COUNT_PJ, "K")) For i = 3 To COUNT_PJ If .Cells(i, "K").Value = "NG" Then COUNT_NEWPJ = .Range("B3").End(xlDown).Row + 1 .Range(.Cells(i, "I"), .Cells(i, "J")).Copy .Cells(COUNT_NEWPJ, "B").PasteSpecial Paste =xlValues .Cells(COUNT_NEWPJ, "D").Formula = "=SUBSTITUTE(LEFTB(CONCATENATE(IF(B" COUNT_NEWPJ " =1000,B" COUNT_NEWPJ ",0 B" COUNT_NEWPJ "),C" COUNT_NEWPJ "),30),""/"","" "")" .Cells(COUNT_NEWPJ, "E").Formula = "=VLOOKUP($B" COUNT_NEWPJ "," RANGE_ST管理表 "," COLUMN_ST管理表 ",0)" END_NEWPJ = END_NEWPJ + 1 End If Next .Range("F3").Formula = "=VLOOKUP($B3," RANGE_ST管理表 "," COLUMN_ST管理表 ",0)" .Range("G3").Formula = "=IF($E3=$F3,""OK"",""NG"")" .Range("F3", "G3").Copy .Paste Range(.Range("F3"), .Cells(END_NEWPJ - 1, "F")) End With //--新規PJのPLシート追加 テスト用 START_NEWPJ = 225 END_NEWPJ = 226 新規PJPLに関する情報を追記用PLに代入 For j = START_NEWPJ To END_NEWPJ - 1 With Worksheets(SHEET_追記用PL) .Range("B2") = Worksheets(SHEET_存在判定).Cells(j, "B").Value .Range("E2") = Worksheets(SHEET_存在判定).Cells(j, "C").Value SHEET_NEWPJPL = Worksheets(SHEET_存在判定).Cells(j, "D").Value JUDGE_GP = Worksheets(SHEET_存在判定).Cells(j, "E").Value グループ判定 グループ判定 JUDGE_GP, FILE, FILE_AM1部, FILE_AM2部, FILE_MM室, FILE_IMS合計 If JUDGE_GP = "アカウントマネジメント1部" Then FILE_追記 = FILE_AM1部 ElseIf JUDGE_GP = "アカウントマネジメント2部" Then FILE_追記 = FILE_AM2部 ElseIf JUDGE_GP = "メディアマーケティング室" Then FILE_追記 = FILE_MM室 Else FILE_追記 = FILE_IMS合計 End If 新規PJPL追加 .Copy Before =Workbooks(FILE_追記).Worksheets("●") End With シート名を変更して、マクロシートに戻る ActiveSheet.Name = SHEET_NEWPJPL Workbooks(FILE_MACRO).Activate Next PJの部門が変更になったシートを移動させる With Worksheets(SHEET_存在判定) For j = 3 To START_NEWPJ - 1 If Cells(j, "G") = "NG" Then BEFORE_GP = .Cells(j, "E").Value AFTER_GP = .Cells(j, "F").Value グループ判定 BEFORE_GP, BEFORE_FILE, FILE_AM1部, FILE_AM2部, FILE_MM室, FILE_IMS合計 グループ判定 AFTER_GP, AFTER_FILE, FILE_AM1部, FILE_AM2部, FILE_MM室, FILE_IMS合計 BEFOREファイル呼び出し 該当シート捜索 AFTERシートに移動 //--各データで数値代入※合計データのみフラグ「1」を立てる 数値代入 FILE_AM1部, 0, PATH_PJ列別PL_外部用, COLUMN_MONTH 数値代入 FILE_AM2部, 0, PATH_PJ列別PL_外部用, COLUMN_MONTH 数値代入 FILE_MM室, 0, PATH_PJ列別PL_外部用, COLUMN_MONTH 数値代入 FILE_IMS合計, 1, PATH_PJ列別PL_外部用, COLUMN_MONTH //--IMS合計の総計PL金額とマクロのPJ列別PLの各行合計と一致するか確認する With Workbooks(FILE_MACRO).Worksheets(SHEET_PJ列別PL) .Activate COUNT_PJ = .Range("A7").End(xlToRight).Column .Cells(7, COUNT_PJ + 1).Value = "PJ合計" .Cells(7, COUNT_PJ + 2).Value = "IMS合計PLより" .Cells(7, COUNT_PJ + 3).Value = "差異" .Cells(8, COUNT_PJ + 1).Formula = "=SUM(C8:" Cells(8, COUNT_PJ).Address(0, 0) ")" .Cells(8, COUNT_PJ + 3).Formula = "=" Cells(8, COUNT_PJ + 2).Address(0, 0) "-" Cells(8, COUNT_PJ + 1).Address(0, 0) .Range(Cells(8, COUNT_PJ + 1), Cells(8, COUNT_PJ + 3)).Copy .Paste Range(Cells(8, COUNT_PJ + 1), Cells(112, COUNT_PJ + 1)) End With Workbooks(FILE_IMS合計).Worksheets(1).Activate Range(Cells(4, COLUMN_MONTH), Cells(108, COLUMN_MONTH)).Copy Workbooks(FILE_MACRO).Worksheets(SHEET_PJ列別PL).Activate ActiveSheet.Cells(8, COUNT_PJ + 2).PasteSpecial Paste =xlValues Exit Sub エラー発生時の処理 エラー処理 MsgBox Err.Number " " Err.Description End Sub
https://w.atwiki.jp/rioatwiki/pages/15.html
World News Today BBC Mexico truck crash At least 49 people killed as trailer overturns Johnson's press chief spoke at No 10 party last year Jussie Smollett Actor found guilty of lying about attack Beijing Winter Olympics boycott is insignificant, says Macron Astroworld Travis Scott says he was unaware fans were hurt How a Russian invasion of Ukraine could spill over into Europe New York’s Met museum to remove Sackler name from exhibits Capitol riot US appeals court rejects Trump's request to block files Ghislaine Maxwell Jury sent home for day after lawyer falls sick Starbucks to get its first unionised US store since 1980s Kenya police recruits brag 'We are the bad ones' US-led coalition against IS ends combat mission in Iraq Woman fined €1,200 for causing Tour de France pile-up Sienna Miller says Sun illegally sought medical records of pregnancy Quiz of the week Which 'nerdy' hobby is Superman Henry Cavill into? Carolina García The woman deciding what you watch Africa's week in pictures 3 - 9 December 2021 And Just Like That 'Moodier' Sex and the City revival splits opinion In pictures Israel hands seized relics to Egypt Growing up in Iran Every morning we had to chant ‘Death to America’ Where are Afghanistan's women MPs now? Valérie Pécresse Part-Thatcher, part-Merkel and wants to run France 'It was magical' - meet the first disabled crew to fly in zero-gravity Madagascar food crisis How a woman helped save her village from starvation The Nepalese children made to work in bars and clubs The country that is Europe's hub for cargo bikes British waste dumped in Romania Why is the UK PM under pressure over a Christmas party? Myanmar coup The women abused and tortured in detention Leicester knocked out of Europa League in dramatic finish to group I'm treated differently to other drivers - Verstappen Tottenham's match at Brighton postponed after Covid cases in Spurs camp Premier League clubs told to return to emergency Covid-19 measures Dunne found guilty of bullying fellow jockey Frost Rangers end Europa League group campaign with draw in Lyon Afghan women Secret diaries of changing lives Max Verstappen Formula 1's 'bull fighter' the family that shaped him The ‘gals’ behind Samoa’s first woman PM Juan Jose Florian Colombia's Para-cycling 'superhero' and his dramatic life story Arthur Labinjo-Hughes A life cut short by cruelty 40 item(s) Last-Modified 2021/12/10 11 17 49 Washington Post showrss プラグインエラー RSSが見つからないか、接続エラーです。 Financial Times UK Johnson braced for big Tory rebellion over Covid measures Ministers rule out further business support under new Covid restrictions Johnson bets on a ‘dead cat’ strategy to get him out of trouble Disney’s chief on his war with Netflix, irking the talent and breaking with the past Meme mania is reshaping US markets The world needs to set new rules in space Covid curbs will have limited impact on UK recovery, say economists Austrians who refuse Covid jabs face fines of up to €3,600 England’s new Covid restrictions what are they and what is the reaction? Biden reaffirms US’s ‘unwavering commitment’ to Ukrainian sovereignty America is still a dangerous nation Latest news updates Asian stocks fall as traders return to cautious outlook When does too much progress become a bad thing? Shein the Chinese company storming the world of fast fashion US commander warns ‘robust range of military options’ exist to deter Iran US spooks allies by seeking ways to clarify nuclear weapons posture Joe Biden must show leadership on nuclear weapons US to blacklist Chinese AI company SenseTime over Xinjiang ahead of IPO US Senate paves way for raising debt ceiling US places visa restrictions on Isabel dos Santos for alleged corruption SEC chair orders staff to recommend new investor protections for Spacs Nubank shares jump on first day of trading in New York Macron calls for EU to strengthen borders and forge closer defence ties UK-EU trade is about to get a lot more complicated UK warned its new immigration rules will harden Irish land border US-born businessman jailed in Russia on fraud charge Kremlin penetrates deeper into online world of Russians Inflation tracker the latest figures as countries grapple with rising prices 28 item(s) Last-Modified 2021/12/10 09 54 16 Financial Times Asia showrss プラグインエラー RSSが見つからないか、接続エラーです。 Japan Today showrss プラグインエラー RSSが見つからないか、接続エラーです。
https://w.atwiki.jp/hinanawiki/pages/116.html
このwiki内でまとめた個人HP,サークルHP,企業HP等のリンク集 リンク貼ってないHPもリスト目的で載せています 英数 / 仮名・漢字 ABCDEFG HIJKLMN OPQRSTU VWXYZ 数字/記号 ABCDEFG Acacia Avenue Artworks 缶バッジ ALiCE'S EMOTiON 楽曲アレンジ / 楽曲アレンジ(Vocal) ALTERNATIVE 楽曲アレンジ Angel of BlueSky ストラップ / 情報機器関係品 / その他(グッズ) AniPix 楽曲アレンジ / 漫画(一般) AQUASTYLE RPG / カードゲーム / カード/カード関係 / 楽曲アレンジ / 楽曲アレンジ(ゲームサントラ) Arc en Ciel 缶バッジ Are Core(アレトコレ) 漫画(一般) Art Book Chipika 漫画(一般) / 漫画(成人) / イラスト集 / 楽曲アレンジ / 缶バッジ / その他(グッズ) Assaultdoor 人形類 α-storage その他(ゲーム) A-Symmetry その他(グッズ) AT project 夢幻 カードゲーム / カード/カード関係 at the mercy of sounds 楽曲アレンジ Azure Sands 楽曲アレンジ B・G・Rock ストラップ BIBASUKU 漫画(一般) BirdStrike アクションゲーム BLACK LABEL その他(グッズ) BlackRockONE アクションゲーム BL-Records 楽曲アレンジ Blue-moment その他(グッズ) B・O・M R-18 イラスト集 Brisa Marina 缶バッジ ChongYoke 楽曲アレンジ(Vocal) Cis-Trance 楽曲アレンジ Coolier シミュレーションゲーム Cloud Palette 缶バッジ CRESCENDO DREAM 漫画(一般・合同) Crest 楽曲アレンジ(Vocal) Crimson Moon 楽曲アレンジ CYTOKINE 楽曲アレンジ C9 楽曲アレンジ Dark PHOENiX 楽曲アレンジ DANGOYA イラスト集 / カードゲーム D.D.D 抱き枕カバー / その他(グッズ) D-east ストラップ / キーホルダー / 缶バッジ / シール depthbomb 18歳未満閲覧禁止 イラスト集 D-heaven 漫画(成人) D.N.A. Softwares テーブル/ボードゲーム EastNewSound 楽曲アレンジ / 楽曲アレンジ(Vocal) <echo>PROJECT 楽曲アレンジ ELField 楽曲アレンジ / テーブル/ボードゲーム eS=S 楽曲アレンジ Eternal Liberty カードゲーム Eternal 17 楽曲アレンジ(Vocal) en-fran 楽曲アレンジ(Vocal) ERA FEEL R-18 漫画(成人) / 缶バッジ blanlink(eXtra_Planet){http //extraplanet.web.fc2.com/data/top.html} カードゲーム Fake gate イラスト集 Fluidstanc 楽曲アレンジ FocasLens RPG Foxtail-Grass Studio 楽曲アレンジ FragileOnline 楽曲アレンジ fromadistance 楽曲アレンジ FRONTIER CREATE 楽曲アレンジ / 楽曲アレンジ(Vocal) / その他(グッズ) GET IN THE RING 楽曲アレンジ(Vocal) Go A Round 楽曲アレンジ Golden City Factory 楽曲アレンジ DRAGON PANDA 漫画(一般) GREEN MORE LIFE RPG HIJKLMN HappyBirthday 漫画(一般) / 漫画(成人) / イラスト集 HAPPY CLOVER 楽曲アレンジ / 楽曲アレンジ(Vocal) / 漫画(一般) happy flame time 漫画(一般) Heliotrope その他(グッズ) honeyblue 漫画(一般) / 缶バッジ Honey Label その他(ゲーム) Iemitsu. 楽曲アレンジ IKB 衣類・装身具 IRON ATTACK! 楽曲アレンジ / 楽曲アレンジ(Vocal) iSweets ストラップ Innocent Key 楽曲アレンジ(Vocal) JACK JOKER 9 漫画(一般) Keio Digital Vertex その他(ゲーム) KGB R-18 イラスト集 knights of Round 楽曲アレンジ komkom.com その他(グッズ) Kraster 楽曲アレンジ(Vocal) k-waves LAB 楽曲アレンジ LABELOPORT 漫画(一般・合同) Lagrangian-POINT R-18 漫画(成人) Lapis moss 楽曲アレンジ(Vocal) LiLA'c Records 楽曲アレンジ(Vocal) LIMIT 漫画(一般・合同) LION HEART アクション Little*Little ストラップ / その他(グッズ) loiter イラスト集 Lupinus 缶バッジ Medium bodied R-18 その他(読聞観) MILK BAR 漫画(一般) / 漫画(一般・合同) /漫画(成人) MINXX キーホルダー MOVE その他(グッズ) M.I.W vision system[DA,BA] カードゲーム / カード/カード関係 MN-logic24 楽曲アレンジ(Vocal) M261 その他(グッズ) M3tamix 楽曲アレンジ N´ 衣類・装身具 NECO湘南 カード/カード関係 Neetpia シミュレーションゲーム NoName? シール / 情報機器関係品 / その他(グッズ) OPQRSTU OG-G Music Works 楽曲アレンジ Oriental Lattice 漫画(一般) Orpheus 楽曲アレンジ Owata Cafe 漫画(一般・合同) NEUTRAL 楽曲アレンジ / 楽曲アレンジ(Vocal) / その他(グッズ) PhantomMist 楽曲アレンジ PARANOIA PARADOX 楽曲アレンジ(Vocal) PASTEL JAM ストラップ/その他(グッズ) Poplica* 楽曲アレンジ(Vocal) Practical Eden 漫画(一般) PROJECT AD カードゲーム Project-R農業協同組合 幻想鏡現詩 カードゲーム R-25 その他(グッズ) Rainbow Vanilla 缶バッジ / イラスト集 ReadyToCreate アクションゲーム / 人形類 ReBELLaRT R-18 その他(読聞観) RHYTH 楽曲アレンジ Riverside 楽曲アレンジ(Vocal) Rolling Contact 楽曲アレンジ ROUGH TIME 楽曲アレンジ(Vocal) Rurirara* 漫画(一般) Sacred Spell 漫画(一般) SASUKEの里 漫画(一般) SIDEREAL カード/カード関係 / 缶バッジ / その他(グッズ) Siestail 楽曲アレンジ / 楽曲アレンジ(Vocal) Silly Walker 閉鎖 楽曲アレンジ / 楽曲アレンジ(Vocal) SILVER BLITZ カードゲーム / カード/カード関係 SJV-SC 楽曲アレンジ SOUND HOLIC 楽曲アレンジ(Vocal) / その他(読聞観) Sound∞Infinity 楽曲アレンジ sound sepher 楽曲アレンジ Sound skt 楽曲アレンジ sssの給湯室 漫画(一般) StrangeChameleon 缶バッジ / 漫画(一般) Strongminded イラスト集 Studio FE キーホルダー / その他(グッズ) Studio Syrup Comfiture 楽曲アレンジ(Vocal) SYNC.ART'S 楽曲アレンジ(Vocal) TACO 漫画(一般) TAMMUSIC 楽曲アレンジ TEDDY-PLAZA 漫画(一般) / 缶バッジ TRICHROMATIC 楽曲アレンジ TEEN MEMORY 缶バッジ TUMENECO 楽曲アレンジ / 楽曲アレンジ(Vocal) Twin Box シール Undefined Field 楽曲アレンジ US escape 楽曲アレンジ UZBL! 漫画(一般) / アクションゲーム VWXYZ VAGUEDGE 楽曲アレンジ(Vocal) Walhalla カードゲーム VISITA 漫画(一般・合同) Walfas その他(ゲーム) WC工房 情報機器関係品 / その他(ゲーム) / その他(グッズ) White Elephant 楽曲アレンジ(Vocal) XL Project 楽曲アレンジ 3Frest その他(グッズ) 数字/記号 3/2 楽曲アレンジ 39xream 漫画(一般) 5150 楽曲アレンジ / 楽曲アレンジ(Vocal) ⑨ウリバタケ 楽曲アレンジ(Vocal) @aa その他(読聞観)
https://w.atwiki.jp/vocaloidenglishlyric/pages/1199.html
【Tags 164 40meterP Miku tF M】 Original Music title 未来線 English music title Future Line / Future Horizon Romaji music title Miraisen Lyrics written by 40㍍P (40meterP) Music written by 164 Music arranged by 40㍍P (40meterP) 164 Singer(s) 初音ミク (Hatsune Miku) Click here for the original Japanese Lyrics English Lyrics (translated by animeyay): I ran into my past self on the station platform where I was standing still. She was staring at me with her ultra clear pupils. "Have you changed, even slightly?" My past self asked me. "I ve become stronger, slightly." I lied to her. Saying nothing, without crying, she smiled at me. I have always hated my past self. Before you disappeared, before I would forget you, I called out your name. Inside my disappeared dream, I ran into my future self. She was staring at me with her ultra tired eyes. "Have you changed, even slightly?" I asked my future self. "I ve become stronger, slightly." I could tell she was only acting strong. I know very well that is a lie, merely feigned toughness. I know you better than anyone else does. Before you disappeared, before I would forget you, you called out my name. Saying nothing, without crying, she smiled at me. I have always hated my past self. It matters not if it s a lie or feigned toughness. You should just live life the way you want. I will come to see you someday in this town, for sure, at the future s horizon. Nobody is there now on the distancing station platform. The color of the cleared sky is the same as always. Romaji lyrics (transliterated by animeyay): tachidomatta eki no hoomu ano hi no jibun ni deaeta sumiwatatta sono hitomi de boku o mitsumete ta "honno chotto kawareta?" tte ano hi no jibun ga tazuneta "honno chotto tsuyoku nareta" to ka uso o tsuita n da nani mo iwanaide naki mo shinaide hohoende ta boku ga zutto kirai datta no hi no boku kiete yuku mae ni wasureru mae ni kimi no namae yonda kiekakatta yume no naka de mirai no jibun ni deaeta tsukarekitta sono hitomi de boku o mitsumete ta "honno chotto kawareta?" tte mirai no jibun ni tazuneta "honno chotto tsuyoku nareta" to ka tsuyogatte ta n da sore ga uso datte tsuyogari datte wakatte ru yo kimi no koto wa ichiban boku ga shitte iru yo kiete yuku mae ni wasureru mae ni boku no namae yonda nani mo iwanaide naki mo shinaide hohoende ta boku ga zutto kirai datta no hi no boku sore ga uso datte tsuyogari datte kamawanai yo kimi ga ima mo kimi no mama de ikite ireba kono machi de itsuka kimi no moto e ai ni yuku yo kitto, miraisen de toozakatta eki no hoomu soko ni wa dare mo inakute harewatatta sora no iro wa kyou mo kawaranai [1640mP, 164, 40m-P, 40mP, 40meter-P, 40meterP]
https://w.atwiki.jp/muvluv/pages/13.html
Characters Main characters (Extra/Unlimited/Alternative) Shirogane Takeru (白銀武) Voice Soichiro Hoshi|Hoshi Souichiro (保志総一朗) Extra- The protagonist, a third-year Hakuryou Hiiragi student. Unlimited/Alternative- The protagonist, who one day finds himself in a parallel world. Kagami Sumika (鑑純夏) Voice Hiroko Taguchi|Taguchi Hiroko (田口宏子) Extra- Takeru's childhood friend and classmate. They've been together for so long that he can't imagine what life would be like without her. Unlimited/Alternative- A brain in a tube. Mitsurugi Meiya (御剣冥夜) Voice Kazumi Okushima|Okushima Kazumi (奥島和美) Extra- A rich girl who showed up in Takeru's bed one day. Unlimited/Alternative- A cadet in unit 207, and later a pilot in squad A-01. Also the shogun's twin sister. Sakaki Chiduru (榊千鶴) Voice Masayo Kurata|Kurata Masayo (倉田雅世) Extra- Chairman of Takeru's class. Constantly at loggerheads with Kei. Used to be captain of the Lacrosse club. Unlimited/Alternative- A cadet in unit 207, and later a pilot in squad A-01. Still at loggerheads with Kei. Ayamine Kei (彩峰慧) Voice Yuuko Nagashima|Nagashima Yuuko (永島由子) Extra- One of Takeru's classmates. Strange. Constantly at loggerheads with Chizuru. Unlimited/Alternative- A cadet in unit 207, and later a pilot in squad A-01. Still strange, and still constantly at loggerheads with Chiduru. Tamase Miki (珠瀬壬姫) Voice Hitomi (ひと美) Extra- The class mascot. Unlimited/Alternative- A cadet in unit 207, and later a pilot in squad A-01. Specializes in sniping. Yoroi Mikoto (鎧衣尊人) Voice Megumi Kubota|Kubota Megumi (久保田恵) Extra- One of Takeru's classmates, who plays Valgern-On with him quite often. Seemingly male. Jinguuji Marimo (神宮司まりも) Voice Miki Inoue|Inoue Miki (井上美紀) Extra- Form and English teacher of Takeru's class. Yuuko's best friend since their school days. Unlimited/Alternative- Unit 207's instructor. Kouduki Yuuko (香月夕呼) Voice Emi Motoi|Motoi Emi (本井えみ) Extra- A physics teacher. Marimo's best friend since their school days. Unlimited/Alternative- Vice-commander of the Yokohama base. Working on mankind's last hope, Alternative IV. Main characters (Unlimited/Alternative) Yoroi Mikoto (鎧衣美琴) Voice Megumi Kubota|Kubota Megumi (久保田恵) A cadet in unit 207, and later a pilot in squad A-01. Definitely female. Yashiro Kasumi (社霞) Voice Minami Kuribayashi|Kuribayashi Minami (栗林みな実) A mysterious girl who can be found in a certain room on floor B-19 of the Yokohama base which has a brain in a cylinder. Has something to do with Alternative IV. Main characters (Alternative) 00 Unit/Kagami Sumika (00ユニット/鑑純夏) Voice Hiroko Taguchi|Taguchi Hiroko (田口宏子) The 00 Unit, humanity's trump card in the battle against the BETA, a quasi-clone-thing of Sumika with the contents of her brain (but not the still-living brain itself, which was killed in the process of her creation). Isumi Michiru (伊隅みちる) Voice Kumiko Watanabe|Watanabe Kumiko (渡辺久美子) From Kimi ga Ita Kisetsu. Captain of squad A-01. Hayase Mitsuki (速瀬水月) Voice Chiaki Takahashi|Takahashi Chiaki (たかはし智秋) From Kimi ga Nozomu Eien. A member of squad A-01. Suzumiya Haruka (涼宮遙) Voice Minami Kuribayashi|Kuribayashi Minami (栗林みな実) From Kimi ga Nozomu Eien. A member of squad A-01. Munakata Misae (宗像美冴) Voice Yuu Asakawa|Asakawa Yuu (浅川悠) A member of squad A-01. Kazama Touko (風間梼子) Voice Shizuka Itou|Itou Shizuka (伊藤 静) A member of squad A-01. Sub-characters (Extra/Unlimited/Alternative) Tsukuyomi Mana (月詠真那) Voice Chizuko Hoshino|Hoshino Chizuko (星野千寿子) Extra- A shotakon ninja maid. Unlimited/Alternative- A first lieutenant in the imperial defence army. Kamiyo Tatsumi (神代巽) Voice Hyousei (氷青) Extra- A ninja maid trainee. Unlimited/Alternative- A second lieutenant in the imperial defence army. Tomoe Yukino (巴雪乃) Voice Rituko Kasai|Kasai Rituko (笠井律子) Extra- A ninja maid trainee. Unlimited/Alternative- A second lieutenant in the imperial defence army. Ebisu Minagi (戎美凪) Voice Aya Sakaguchi|Sakaguchi Aya (阪口あや) Extra- A ninja maid trainee. Unlimited/Alternative- A second lieutenant in the imperial defence army. Suzumiya Akane (涼宮茜) Voice Kaori Mizuhashi|Mizuhashi Kaori (水橋かおり) Extra- From Kimi ga Nozomu Eien. A friend and rival of Chiduru's. Alternative- A member of squad A-01. Ichimonji Takahashi (一文字鷹嘴) Voice Takehito Koyasu|Koyasu Takehito (子安武人) Extra- Meiya's chauffeur, who drives an extremely long limousine. Parody of Takahashi Ryousuke from Initial D. Alternative- Captain of the destroyer Yuunagi. Kashiwagi Haruko (柏木晴子) Voice Chie Matuura (松浦チエ) Extra- One of Takeru's classmates. Alternative- A member of squad A-01. Sagiri Naoya (沙霧尚哉) Voice Takehito Koyasu|Koyasu Takehito (子安武人) Extra- A doctor. Alternative- A captain in the imperial defence army's capital defence forces. Tamase Genjousai (珠瀬玄丞斎) Voice Tetsu Inada|Inada Tetsu (稲田徹) Extra- Miki's father. Unlimited/Alternative- Under-secretary-general of the United Nations and Miki's father. Sub-characters (Unlimited/Alternative) Paul Radhabinod (パウル・ラダビノッド) Voice Norio Wakamoto|Wakamoto Norio (若本規夫) Commander of the Yokohama base. Kyoudzuka Shidzue (京塚志津江) Voice Ayumi Kida|Kida Ayumi (喜田あゆ美) A woman who works in the Yokohama base cafeteria. Elena Piatif (イリーナ・ピアティフ) Voice Naoko Takano|Takano Naoko (高野直子) A Yokohama base communications officer, and Kouduki's secretary. Rank is first lieutenant. Sub-characters (Alternative) Koubuin Yuuhi (煌武院悠陽) Voice Kozue Yoshizumi (吉住梢) The shogun and Meiya's twin sister. Yoroi Sakon (鎧衣左近) Voice Masaaki Yajima|Yajima Masaaki (沢木郁也) Section chief of the second division of the imperial information agency, and Mikoto's father. Alfred Walken (アルフレッド・ウォーケン) Voice Takashi Maejima|Maejima Takashi (前島貴志) A major in the American army. Irma Thesleff (イルマ・テスレフ) Voice Kiyomi Asai|Asai Kiyomi (浅井清己) A second lieutenant in the American army. Originally from Finland, which was destroyed by the BETA. Homura Manami (穂村愛美) Voice Maki Amamiya|Amamiya Maki (尼子真理) From Kimi ga Nozomu Eien. An orderly in the Yokohama base. Main characters (Total Eclipse) Yuuya Bridges (ユウヤ・ブリッジス) The protagonist of Total Eclipse. A Japanese American. From the American army. Takamura Yui (篁唯依) Japanese. From the imperial Japanese army. Kriska Barchenowa (クリスカ・ビャーチェノワ) Russian test pilot. From the Soviet army. Inia Jestina (イーニァ・ジェスチナ) Russian test pilot. From the Soviet army. Tarisa Manandal (タリサ・マナンダル) Gurkha from the Nepalese army. Vincent Lowell (ヴィンセント・ローウェル) American mechanic. Other characters Nanase Rin (七瀬凛) First introduced in Muv-Luv Duelist, and has made no other appearances. Voice Natsumi Suzuhara|Suzuhara Natsumi (鈴原なつみ) Gouda Jouji (剛田城二) First introduced in Akane Maniax, and last seen in the Kimi ga Nozomu Eien|Kiminozo fandisc's short story, "TRUE LIES", he returns again in Muv-Luv Duelist. Voice Tomokazu Seki|Seki Tomokazu (関智一) Mitsurugi Raiden (御剣雷電) Meiya's grandfather, seen in the Muv-Luv Supplement short story Waga Na wa Meiya (我が名は冥夜). Looks like a human version of the super robot Raideen. Guren Daizaburou (紅蓮醍三郎) Meiya's master, seen in the Muv-Luv Supplement short story Waga Na wa Meiya (我が名は冥夜). Looks like a human version of the super robot Grendizer (Gurendaizaa). The attacks he uses are all references to Grendizer's weapons (similar names, and they look exactly the same). For example, the attack Hanjuuryoku-no-Arashi (反重力乃嵐) that he uses comes from Grendizer's Hanjuuryoku Storm, and the attack Uchuu-no-Ikazuchi (宇宙乃雷) comes from Grendizer's Space Thunder.
https://w.atwiki.jp/vocaloidenglishlyric/pages/605.html
【Tags Miku buzzG tM M】 Original Music title メリーとニコラウス English music title Merry and Nicolaus Romaji music title Merii to Nikorausu Music Lyrics written, Voice edited by buzzG Music arranged by buzzG Singer(s) 初音ミク (Hatsune Miku) Click here for the original Japanese Lyrics English Lyrics (translated by vgboy / vgperson): "Mister! They say you can make miracles... is that true?" The girl enquired the old man. "Hah... I wonder myself... Maybe you'd call it miracle, maybe not... But I suppose long ago, I used to raise some flying reindeer..." "Wha?! No way! You're a terrible joker, mister!" "Heh heh... Well, now! You ought to be going. I bet your mom'll be angry otherwise." Despite the old man's urging, the girl couldn't accept it. Showing this with her expression, she reluctantly nodded her head. But then, as if just recalling it, the old man said... "Ah, right! Until the next time we meet, think about what it is you want. As thanks for listening to this senile old man and keeping him company, I'll give you whatever you like." "Yaaay! Thank you! You promise?" I've lost the name that God gave to me; All status, honor, and glory is gone now... I was shunned, and made a fool of, but I just laughed it off I saw I was putting on the years, but still I smiled Until you know the meaning of "goodbye," You'll act like it's all just fine - aren't I right? I don't have to the power to make miracles, But I can't help but let out tears... I kept such good care of that old blue clock, But with the second hand stopped, I felt so lonely... I put my own self second, and wished for others' joy, So my declining life could bring smiles elsewhere... Don't go - there's so much I still don't know You cradled me with your great, warm hands, but it still hurt... If you have the power to make miracles, Then please, God, just once more... One day in December, I heard bells from far away, Telling me an old, white-bearded man was coming to see me... Until I know the meaning of "goodbye," You'll act like it's all just fine - aren't I right? Maybe you don't have to the power to make miracles, But there's something far more important... Hey, there's something I want, so please listen; Just put it in my stocking - that's fine, right? Never mind the power to make miracles; I found something much more precious... And it was you who taught it to me... Romaji lyrics (transliterated by vgboy / vgperson): "Oji-san! Kiseki o okoseru tte, hontou?" Shoujo wa roujin ni tazunemasu. "Aa... dou darou nee... Kiseki to yobu no ka wakaranai keredo, Mukashi wa, sora o tobu tonakai o katteita koto mo atta kana..." "Ee, uso da! Oji-san wa joudan ga heta dana!" "Hehe... hora! Sorosoro kaeranaito. Okaa-san ni okorarete shimau yo?" Roujin ga unagasu mo, shoujo wa nattoku wa ikenai. To itta hyoujou de, shibushibu unazukimashita. Suru to, roujin wa omoidashita you ni... "Sou da! Tsugi ni au toki made ni, hoshii mono o kangaete okinasai. Mouroku shita kono jii no hanashi ni tsukiatte kureta orei ni, Suki na mono o ageyou." "Waai! Arigatou! Yakusoku da yo?" Kamisama ga kureta sono namae o nakushite Chii mo meiyo mo eikou mo ushinattan desho Utomarete baka ni sare sore demo waraitobashite Kitsukeba toshi dake kasanete mada waratteta Sayonara no sono imi ga wakaru made no aida Anata wa heiki na furi o shiteta ne nee sou desho Kiseki o okosu chikara mo nai no ni Boroboro namida ga dechau no Sugoku daiji ni shiteta mizuiro no okitokei wa Byoushin ga tomatta manma samishisou ni shiteta Jibun no koto wa ni no tsugi tanin no shiawase negatte Katamuita inochi o yoso ni mata waratteta Ikanaide watashi mada shiranai koto ga aru no Ooki na te de nadete kureta nukumori ga itai yo Kiseki o okosu chikara ga aru nara Kamisama mou ichido dake Juuni-gatsu to aru hi ni suzu no ne ga tooku kikoete Shiroi hige no roujin ga ai ni kuru to iu Sayonara no sono imi ga wakaru made no aida Anata wa heiki na furi o shiteta ne nee sou desho Kiseki o okosu chikara wa nai kedo Sonna no yori mo zutto Nee hoshii mono ga aru no kiite kureru Kutsushita ni irete oite yo nee ii desho Kiseki o okosu chikara nanka yori Daiji na mono o mitsuketa yo Anata ga oshiete kureta yo